Links not updating due to manual update option selected.
Cause:
The manual update option has been selected in the 'Links' dialog box.
Solution:
Select 'Links' from the 'Edit' menu and click 'Update Now' to update manual links.
1) Select the 'Edit' menu and select 'Links...'. (The Links dialog box appears.)
2) Select the link to update from the list box. (The link is highlighted.)
3) Click 'Update Now'.
4) (Optional) Repeat steps 2) and 3) if multiple links in the same workbook need to be updated.
5) Click 'OK' to close the 'Links' dialog box.